Referencing period columns

All XERASperiod-based spreadsheets have the same period column definition as defined in the calendar, therefore, referencing other rows need not have a column reference, for example, qGoldOre * fRecovery. This formula will multiply the quantity of gold ore by a recovery factor, replicating automatically for each period column.

If needing to reference a period within a formula other than the period in which the formula is being calculated, you will need to supply the period (column) reference as well.

Period columns can also be referenced using their period index, rather than the column code. This is a special column reference that allows for period column codes to be modified by changing the calendar periods, without impacting on formulae referencing those periods. Similarly, qGoldOre * fRecovery.1 will reference directly to the first period in the fRecovery row.